Edinburgh’s road network

Edinburgh’s implementation zones

Edinburgh’s control zones

Time series analysis

Mapping accidents with roads: 2013/2014

##                    LAYER Accident_Index
## 1 20mph existing streets            143
## 2    20mph local streets            146
## 3     20mph main streets            400
## 4                  30mph            280
## 5        Part time 20mph              7
## 6            Trunk roads              1

Mapping accidents with roads: 2014/2015

##                    LAYER Accident_Index
## 1 20mph existing streets            102
## 2    20mph local streets            134
## 3     20mph main streets            391
## 4                  30mph            251
## 5        Part time 20mph              7

Mapping accidents with roads: 2015/2016

##                    LAYER Accident_Index
## 1 20mph existing streets            112
## 2    20mph local streets            146
## 3     20mph main streets            359
## 4                  30mph            277
## 5        Part time 20mph              6

Mapping accidents with roads: 2018/2019

##                    LAYER Accident_Index
## 1 20mph existing streets            121
## 2    20mph local streets            164
## 3     20mph main streets            387
## 4                  30mph            327
## 5        Part time 20mph             10

Count pre 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            357
## 2    20mph local streets            426
## 3     20mph main streets           1150
## 4                  30mph            808
## 5        Part time 20mph             20
## 6            Trunk roads              1

Count post 20mph

##                    LAYER Accident_Index
## 1 20mph existing streets            121
## 2    20mph local streets            164
## 3     20mph main streets            387
## 4                  30mph            327
## 5        Part time 20mph             10

Output column: Layer

##   Accident_Index                  LAYER
## 1  2015950002854 20mph existing streets
## 2  2014950003046 20mph existing streets
## 3  2014950005401 20mph existing streets
## 4  2014950001765 20mph existing streets
## 5  2016950000527 20mph existing streets
## 6  2016950002264 20mph existing streets

Table: Average annual road traffic collision rates in the city of Edinburgh

Table 1: Average annual road traffic collision rates in the city of Edinburgh (council data)
collisions pre-20mph ( 2013 / 2016 - 3 years ) collisions post-20mph ( 2018 / 2019 - 22 months ) rate pre-20mph rate post-20mph diff in rates = pre - post Perc.diff.rates = (pre - post) / pre * 100
Streets stayed
at 30mph 809 327 269.67 178.69 90.98 34
at 20mph 357 121 119.00 66.12 52.88 44
Part time 20mph : a traffic calming measure in specific hours per day. e.g outside of schools, at the start and end of the school day 20 10 6.67 5.46 1.21 18
Streets changed
at 30mph changed to 20mph 1576 551 525.33 301.09 224.24 43
All streets
All streets 2762 1009 920.67 551.37 369.30 40
Note:
1 All accidents at 20mph, 30mph

Effect estimate

Total number of collisions in the city of Edinburgh
Tax year 2013/14 2014/15 2015/16 2016/17 2017/18 2018/19 2019/20
Annual number of collisions 977 885 900 Intervention years 581 428
Rate per year 977 885 900 581 515.66
% reduction in collisions 36.25
Calculations
A + B + C / 3 920.67
D + E / 1.83 551.37
A - B / A 9.00
B - C / B -2.00
Unadjusted_estimate 40.00
Secular_trend 4.00
Note:
1 A : accidents 2013/14 ( 1 year )
2 B : accidents 2014/15 ( 1 year )
3 C : accidents 2015/16 ( 1 year )
4 D : accidents 2018/19 ( 1 year )
5 E : accidents 2019/20 ( 10 months )

Mapping accidents with implementation zones : 2013

Mapping accidents with implementation zones: 2014

Mapping accidents with implementation zones: 2015

Mapping accidents with implementation zones: 2016

Mapping accidents with implementation zones: 2017

Mapping accidents with implementation zones: 2018

Output column: Implementation Zone

##   Accident_Index ImplementationZone
## 1  2016950000001                  2
## 2  2016950000003                  2
## 3  2016950000004                  2
## 4  2016950000007                  1
## 5  2016950000047                  3
## 6  2016950000111                  3

Table: Average annual road traffic collision rates in the city of Edinburgh per implementation zone

Table 3: Average annual road traffic collision rates in the city of Edinburgh per implementation zone
Implementation zone collisions pre-20mph collisions post-20mph rate pre-20mph rate post-20mph diff in rates Perc.diff.rates
1a 469 308 156.33 118.46 37.87 24
1b 64 57 21.33 21.92 -0.59 -3
2 645 256 215.00 128.00 87.00 40
3 850 375 283.33 187.50 95.83 34
4 188 68 62.67 45.33 17.34 28
5 268 76 89.33 50.67 38.66 43
6 206 34 68.67 37.78 30.89 45
All zones 2690 1174 896.67 451.54 445.13 50

Control zone 1a:City center –> George St/Harbour, Aberdeen

## [1] 113

Control zone 1b:Rural west –> Tay Bridgehead & St Andrews

## [1] 75

Control zone 3:South central –> Dundee

## [1] 519

Control zone 4:North west -> Renfrew North, Renfrew South & Gallowhill, Paisley North West

## [1] 311

Control zone 5:West –> Glasgow Kelvin

## [1] 1048

Control zone 6:South –> Paisley

## [1] 390

Updated dataset for Edinburgh

##   Accident_Index Control_zone
## 1  2013921302856           1a
## 2  2013921303288           1a
## 3  2013921303410           1a
## 4  2013921303560           1a
## 5  2013921303685           1a
## 6  2013921303761           1a
##   Accident_Index Shape_Length Control_zone DataZone
## 1  2016950000001    24260.236         <NA>     <NA>
## 2  2016950000003    24260.236         <NA>     <NA>
## 3  2016950000004    24260.236         <NA>     <NA>
## 4  2016950000007     7906.803         <NA>     <NA>
## 5  2016950000047    33866.010         <NA>     <NA>
## 6  2016950000111    33866.010         <NA>     <NA>